IMPORTANT: Please make sure you create a copy of this file with a customized name, so that your work (e.g. answers to the questions) is not over-written when you pull the latest content from the course github.

The purpose of this exercise is to become familiar with:

  1. Some time series analysis tools;
  2. Correlation matrices and principal component analysis (PCA) (see readings of sessions 3-4);
  3. More data manipulation and reporting tools (including Google Charts).

As always, while doing this exercise we will also see how to generate replicable and customizable reports. For this purpose the exercise uses the R Markdown capabilities (see Markdown Cheat Sheet or a basic introduction to R Markdown). These capabilities allow us to create dynamic reports. For example today’s date is 2017-01-23 (you need to see the .Rmd to understand that this is not a static typed-in date but it changes every time you compile the .Rmd - if the date changed of course).

Before starting, make sure you have pulled the exercise set 2 souce code files on your github repository (if you pull the course github repository you also get the exercise set files automatically). Moreover, make sure you are in the directory of this exercise. Directory paths may be complicated, and sometimes a frustrating source of problems, so it is recommended that you use these R commands to find out your current working directory and, if needed, set it where you have the main files for the specific exercise/project (there are other ways, but for now just be aware of this path issue). For example, assuming we are now in the “Data Analytics R version/INSEADAnalytics” directory, we can do these:

getwd()
setwd("Exercises/Exerciseset2/")
list.files()

Note: as always, you can use the help command in Rstudio to find out about any R function (e.g. type help(list.files) to learn what the R function list.files does).

Let’s now see the exercise.

IMPORTANT: You should answer all questions by simply adding your code/answers in this document through editing the file ExerciseSet2.Rmd and then clicking on the “Knit HTML” button in RStudio. Once done, please post your .Rmd and html files in your github repository.

The Exercise: Introduction

For this exercise we will use the Futures’ daily returns to develop what is considered to be a “classic” hedge fund trading strategy, a futures trend following strategy. There is a lot written about this, so it is worth doing some online search about “futures trend following”, or “Managed Futures”, or “Commodity Trading Advisors (CTA)”. There is about $300 billion invested on this strategy today, and is considered to be one of the oldest hedge fund strategies. Some example links are:

Of course there are also many starting points for developing such a strategy (for example this R bloggers one (also on github), or the turtle traders website which has many resources.

In this exercise we will develop our own strategy from scratch.

Note (given today’s market conditions): Prices of commodities, like oil or gold, can be excellent indicators of the health of the economy and of various industries, as we will also see below.

Getting the Futures Data

There are many ways to get futures data. For example, one can use the Quandl package, or the turtle traders resources, or (for INSEAD only) get data from the INSEAD library finance data resources website. One has to pay attention on how to create continuous time series from underlying contracts with varying deliveries (e.g. see here ). Using a combination of the resources above, we will use data for a number of commodities.

Data description

Let’s load the data and see what we have.

We have data from 2001-01-02 to 2015-09-24 of daily returns for the following 64 futures:

##  [1] "Corn"               "Wheat"              "Soybeans"          
##  [4] "Soybean Oil"        "Soybean Meal"       "Lean Hoggs"        
##  [7] "Sugar"              "Coffee"             "Cocoa"             
## [10] "Cotton"             "Canola"             "Orange Juice"      
## [13] "Lumber"             "Natural Gas"        "Crude Oil"         
## [16] "Brent Crude"        "Heating Oil"        "Kerosene"          
## [19] "Gas Oil"            "Gasoline"           "Copper NY"         
## [22] "Copper LDN"         "Silver"             "Gold"              
## [25] "Platinum"           "Palladium"          "Aluminium"         
## [28] "Zinc"               "Nickel"             "Treasury Bonds"    
## [31] "5 yr T-Notes US"    "2 yr T-Note US"     "10yr T-Notes"      
## [34] "Euro-Bund"          "Euro-Bobl"          "Euro-Schatz"       
## [37] "Canadian Bond"      "JGB Japan"          "Gilts UK"          
## [40] "Euroyen"            "Eurodollar"         "Euroswiss"         
## [43] "Euribor"            "SP500 E-Mini"       "DAX 30"            
## [46] "Eurostoxx"          "Hang Seng"          "FTSE 100 UK"       
## [49] "Nasdaq 100 Mini"    "Russel 2000 E-Mini" "Dow Jones"         
## [52] "TSE Toronto"        "CAC 40 France"      "OMX 30 Stockholm"  
## [55] "NIKKEI 225"         "Euro"               "Norwegian Krone"   
## [58] "New Zealand Dollar" "Australian Dollar"  "British Pound"     
## [61] "Canadian Dollar"    "Swiss Franc"        "Japanese Yen"      
## [64] "Singapore Dollar"

Basic data analysis

Let’s see how these are correlated. The correlation matrix is as follows:

Corn Wheat Soybeans Soybean Oil Soybean Meal Lean Hoggs Sugar Coffee Cocoa Cotton Canola Orange Juice Lumber Natural Gas Crude Oil Brent Crude Heating Oil Kerosene Gas Oil Gasoline Copper NY Copper LDN Silver Gold Platinum Palladium Aluminium Zinc Nickel Treasury Bonds 5 yr T-Notes US 2 yr T-Note US 10yr T-Notes Euro-Bund Euro-Bobl Euro-Schatz Canadian Bond JGB Japan Gilts UK Euroyen Eurodollar Euroswiss Euribor SP500 E-Mini DAX 30 Eurostoxx Hang Seng FTSE 100 UK Nasdaq 100 Mini Russel 2000 E-Mini Dow Jones TSE Toronto CAC 40 France OMX 30 Stockholm NIKKEI 225 Euro Norwegian Krone New Zealand Dollar Australian Dollar British Pound Canadian Dollar Swiss Franc Japanese Yen Singapore Dollar
Corn 1.00 0.63 0.60 0.51 0.52 0.02 0.21 0.17 0.10 0.23 0.45 0.06 0.08 0.12 0.24 0.25 0.22 0.02 0.15 0.25 0.23 0.22 0.23 0.18 0.13 0.17 0.20 0.18 0.16 -0.08 -0.07 -0.05 -0.07 -0.08 -0.06 -0.08 -0.07 -0.03 -0.06 -0.01 -0.01 -0.05 -0.07 0.14 0.13 0.13 0.08 0.16 0.10 0.12 0.11 0.18 0.13 0.15 0.05 0.17 0.20 0.18 0.21 0.16 -0.20 0.11 -0.02 0.17
Wheat 0.63 1.00 0.45 0.42 0.39 0.03 0.20 0.18 0.09 0.22 0.38 0.03 0.07 0.09 0.21 0.21 0.18 0.00 0.12 0.21 0.21 0.21 0.20 0.16 0.12 0.15 0.17 0.17 0.14 -0.10 -0.09 -0.07 -0.09 -0.07 -0.06 -0.06 -0.07 -0.02 -0.06 -0.01 -0.04 -0.06 -0.06 0.13 0.13 0.13 0.06 0.15 0.10 0.13 0.11 0.17 0.13 0.13 0.05 0.16 0.20 0.18 0.20 0.15 -0.20 0.12 0.00 0.16
Soybeans 0.60 0.45 1.00 0.74 0.84 0.04 0.20 0.16 0.12 0.26 0.64 0.08 0.08 0.11 0.27 0.27 0.25 0.04 0.18 0.28 0.28 0.26 0.24 0.17 0.17 0.21 0.23 0.21 0.18 -0.12 -0.11 -0.09 -0.11 -0.11 -0.10 -0.10 -0.09 -0.02 -0.12 -0.02 -0.05 -0.09 -0.09 0.15 0.17 0.17 0.13 0.20 0.11 0.14 0.13 0.20 0.18 0.20 0.08 0.17 0.22 0.19 0.25 0.17 -0.22 0.11 -0.01 0.21
Soybean Oil 0.51 0.42 0.74 1.00 0.47 0.04 0.20 0.18 0.13 0.28 0.64 0.10 0.09 0.13 0.34 0.34 0.31 0.09 0.25 0.37 0.32 0.30 0.29 0.23 0.20 0.24 0.27 0.25 0.22 -0.14 -0.12 -0.09 -0.12 -0.11 -0.10 -0.11 -0.10 -0.02 -0.13 0.00 -0.04 -0.08 -0.08 0.20 0.20 0.20 0.19 0.25 0.14 0.19 0.18 0.24 0.22 0.24 0.12 0.20 0.26 0.24 0.30 0.21 -0.28 0.13 -0.05 0.23
Soybean Meal 0.52 0.39 0.84 0.47 1.00 0.02 0.16 0.13 0.09 0.20 0.51 0.08 0.07 0.09 0.17 0.17 0.16 0.02 0.11 0.17 0.20 0.18 0.17 0.12 0.12 0.15 0.16 0.15 0.13 -0.08 -0.08 -0.07 -0.08 -0.07 -0.07 -0.07 -0.06 -0.02 -0.08 -0.01 -0.04 -0.07 -0.07 0.10 0.13 0.13 0.09 0.15 0.08 0.09 0.09 0.15 0.13 0.15 0.07 0.13 0.16 0.15 0.19 0.12 -0.17 0.08 0.01 0.16
Lean Hoggs 0.02 0.03 0.04 0.04 0.02 1.00 0.03 0.02 0.03 0.02 0.01 0.01 0.03 0.04 0.07 0.06 0.05 -0.02 0.02 0.05 0.06 0.06 0.02 0.01 0.05 0.04 0.05 0.07 0.06 -0.04 -0.05 -0.04 -0.04 -0.04 -0.03 -0.02 -0.04 0.01 -0.05 0.00 -0.05 -0.05 -0.04 0.04 0.04 0.06 0.01 0.06 0.01 0.02 0.03 0.05 0.06 0.04 0.02 0.00 0.01 0.01 0.02 0.02 -0.03 -0.02 -0.03 0.01
Sugar 0.21 0.20 0.20 0.20 0.16 0.03 1.00 0.22 0.15 0.19 0.17 0.06 0.04 0.07 0.20 0.19 0.17 0.02 0.14 0.19 0.23 0.21 0.18 0.13 0.12 0.16 0.19 0.18 0.16 -0.07 -0.06 -0.04 -0.06 -0.09 -0.10 -0.09 -0.05 0.00 -0.08 0.00 -0.01 -0.04 -0.06 0.11 0.12 0.13 0.08 0.15 0.08 0.11 0.08 0.13 0.13 0.14 0.08 0.13 0.15 0.17 0.20 0.13 -0.15 0.09 -0.04 0.16
Coffee 0.17 0.18 0.16 0.18 0.13 0.02 0.22 1.00 0.18 0.16 0.12 0.06 0.07 0.05 0.15 0.14 0.13 0.04 0.12 0.15 0.19 0.18 0.20 0.15 0.13 0.17 0.17 0.17 0.15 -0.06 -0.05 -0.03 -0.05 -0.06 -0.06 -0.06 -0.05 0.00 -0.05 -0.01 -0.01 -0.05 -0.04 0.12 0.13 0.13 0.11 0.13 0.07 0.12 0.11 0.14 0.13 0.14 0.07 0.15 0.17 0.19 0.20 0.15 -0.17 0.08 0.00 0.16
Cocoa 0.10 0.09 0.12 0.13 0.09 0.03 0.15 0.18 1.00 0.12 0.08 0.05 0.06 0.04 0.16 0.15 0.13 0.06 0.15 0.14 0.17 0.17 0.21 0.18 0.13 0.14 0.16 0.16 0.12 -0.08 -0.06 -0.02 -0.07 -0.10 -0.09 -0.06 -0.07 -0.01 -0.09 -0.03 -0.01 -0.05 -0.05 0.10 0.11 0.12 0.12 0.11 0.06 0.11 0.09 0.13 0.13 0.14 0.07 0.21 0.22 0.22 0.23 0.24 -0.20 0.14 0.01 0.19
Cotton 0.23 0.22 0.26 0.28 0.20 0.02 0.19 0.16 0.12 1.00 0.22 0.08 0.07 0.04 0.20 0.20 0.18 0.03 0.16 0.19 0.23 0.22 0.17 0.13 0.10 0.15 0.19 0.18 0.18 -0.10 -0.10 -0.08 -0.10 -0.09 -0.09 -0.10 -0.08 -0.02 -0.08 0.01 -0.06 -0.07 -0.07 0.17 0.16 0.17 0.09 0.18 0.13 0.16 0.15 0.18 0.17 0.17 0.05 0.17 0.20 0.17 0.21 0.15 -0.20 0.11 -0.01 0.17
Canola 0.45 0.38 0.64 0.64 0.51 0.01 0.17 0.12 0.08 0.22 1.00 0.06 0.06 0.06 0.17 0.19 0.16 0.03 0.11 0.21 0.18 0.16 0.18 0.13 0.12 0.15 0.15 0.14 0.12 -0.09 -0.09 -0.07 -0.08 -0.06 -0.07 -0.09 -0.05 -0.02 -0.07 -0.01 -0.05 -0.06 -0.09 0.09 0.10 0.10 0.11 0.13 0.07 0.07 0.07 0.16 0.11 0.13 0.06 0.09 0.13 0.11 0.15 0.10 -0.06 0.05 -0.02 0.12
Orange Juice 0.06 0.03 0.08 0.10 0.08 0.01 0.06 0.06 0.05 0.08 0.06 1.00 0.04 0.05 0.10 0.08 0.08 0.04 0.08 0.09 0.09 0.08 0.10 0.06 0.06 0.07 0.10 0.07 0.08 -0.05 -0.03 -0.02 -0.04 -0.06 -0.06 -0.06 -0.07 -0.03 -0.06 -0.02 -0.01 -0.02 -0.04 0.08 0.08 0.09 0.07 0.10 0.06 0.06 0.08 0.10 0.08 0.11 0.07 0.06 0.05 0.07 0.09 0.03 -0.09 0.03 -0.03 0.07
Lumber 0.08 0.07 0.08 0.09 0.07 0.03 0.04 0.07 0.06 0.07 0.06 0.04 1.00 0.00 0.07 0.07 0.07 0.04 0.05 0.09 0.12 0.11 0.07 0.02 0.03 0.06 0.10 0.08 0.09 -0.10 -0.11 -0.09 -0.11 -0.08 -0.08 -0.07 -0.09 0.01 -0.10 -0.01 -0.07 -0.08 -0.06 0.12 0.14 0.14 0.08 0.14 0.12 0.10 0.11 0.10 0.14 0.12 0.04 0.05 0.08 0.09 0.11 0.08 -0.09 0.01 -0.07 0.09
Natural Gas 0.12 0.09 0.11 0.13 0.09 0.04 0.07 0.05 0.04 0.04 0.06 0.05 0.00 1.00 0.29 0.27 0.34 0.00 0.20 0.16 0.10 0.09 0.08 0.07 0.04 0.06 0.09 0.06 0.05 -0.02 -0.02 -0.02 -0.02 0.00 0.00 0.01 -0.02 -0.01 -0.01 0.00 -0.01 -0.01 0.00 0.04 0.04 0.03 0.03 0.04 0.02 0.03 0.03 0.10 0.04 0.04 0.03 0.07 0.07 0.07 0.09 0.06 -0.10 0.06 0.01 0.05
Crude Oil 0.24 0.21 0.27 0.34 0.17 0.07 0.20 0.15 0.16 0.20 0.17 0.10 0.07 0.29 1.00 0.89 0.84 0.10 0.56 0.66 0.37 0.35 0.29 0.26 0.20 0.24 0.30 0.27 0.25 -0.20 -0.14 -0.10 -0.17 -0.15 -0.14 -0.12 -0.15 -0.02 -0.14 -0.03 -0.05 -0.08 -0.08 0.23 0.19 0.20 0.15 0.25 0.13 0.23 0.19 0.33 0.22 0.25 0.10 0.23 0.32 0.25 0.32 0.22 -0.34 0.13 -0.06 0.25
Brent Crude 0.25 0.21 0.27 0.34 0.17 0.06 0.19 0.14 0.15 0.20 0.19 0.08 0.07 0.27 0.89 1.00 0.85 0.11 0.62 0.69 0.36 0.34 0.29 0.25 0.20 0.24 0.29 0.27 0.25 -0.17 -0.13 -0.09 -0.14 -0.13 -0.12 -0.10 -0.13 -0.02 -0.12 -0.01 -0.03 -0.08 -0.07 0.23 0.18 0.19 0.16 0.25 0.13 0.24 0.19 0.33 0.22 0.25 0.12 0.23 0.31 0.26 0.32 0.24 -0.34 0.14 -0.05 0.24
Heating Oil 0.22 0.18 0.25 0.31 0.16 0.05 0.17 0.13 0.13 0.18 0.16 0.08 0.07 0.34 0.84 0.85 1.00 0.10 0.64 0.63 0.31 0.30 0.26 0.23 0.18 0.21 0.25 0.24 0.21 -0.14 -0.10 -0.08 -0.11 -0.10 -0.09 -0.08 -0.11 -0.01 -0.09 -0.02 -0.03 -0.06 -0.05 0.19 0.15 0.15 0.13 0.20 0.11 0.21 0.16 0.28 0.18 0.21 0.10 0.20 0.26 0.22 0.28 0.20 -0.30 0.13 -0.03 0.21
Kerosene 0.02 0.00 0.04 0.09 0.02 -0.02 0.02 0.04 0.06 0.03 0.03 0.04 0.04 0.00 0.10 0.11 0.10 1.00 0.28 0.10 0.09 0.10 0.08 0.05 0.14 0.15 0.10 0.08 0.07 -0.03 -0.01 0.00 -0.02 -0.08 -0.06 -0.05 -0.02 -0.14 -0.11 -0.05 0.02 -0.04 -0.02 0.04 0.07 0.09 0.23 0.11 0.01 0.04 0.03 0.08 0.08 0.11 0.33 0.05 0.12 0.11 0.12 0.10 -0.11 0.04 -0.13 0.05
Gas Oil 0.15 0.12 0.18 0.25 0.11 0.02 0.14 0.12 0.15 0.16 0.11 0.08 0.05 0.20 0.56 0.62 0.64 0.28 1.00 0.40 0.29 0.30 0.24 0.19 0.18 0.21 0.25 0.25 0.21 -0.11 -0.07 -0.04 -0.09 -0.10 -0.09 -0.07 -0.09 -0.03 -0.11 -0.01 -0.01 -0.06 -0.04 0.13 0.15 0.16 0.14 0.21 0.08 0.15 0.11 0.19 0.17 0.21 0.09 0.20 0.29 0.23 0.27 0.20 -0.31 0.16 -0.03 0.21
Gasoline 0.25 0.21 0.28 0.37 0.17 0.05 0.19 0.15 0.14 0.19 0.21 0.09 0.09 0.16 0.66 0.69 0.63 0.10 0.40 1.00 0.36 0.34 0.28 0.23 0.21 0.25 0.30 0.27 0.26 -0.18 -0.15 -0.10 -0.16 -0.15 -0.15 -0.15 -0.15 -0.02 -0.14 -0.05 -0.06 -0.11 -0.12 0.26 0.22 0.23 0.18 0.28 0.16 0.26 0.23 0.35 0.25 0.28 0.13 0.19 0.28 0.23 0.31 0.21 -0.31 0.10 -0.08 0.22
Copper NY 0.23 0.21 0.28 0.32 0.20 0.06 0.23 0.19 0.17 0.23 0.18 0.09 0.12 0.10 0.37 0.36 0.31 0.09 0.29 0.36 1.00 0.91 0.45 0.36 0.31 0.39 0.67 0.68 0.57 -0.20 -0.17 -0.13 -0.18 -0.20 -0.19 -0.17 -0.17 -0.06 -0.19 -0.03 -0.06 -0.14 -0.14 0.28 0.36 0.37 0.25 0.40 0.21 0.23 0.26 0.33 0.38 0.38 0.18 0.29 0.35 0.38 0.45 0.29 -0.38 0.20 -0.08 0.32
Copper LDN 0.22 0.21 0.26 0.30 0.18 0.06 0.21 0.18 0.17 0.22 0.16 0.08 0.11 0.09 0.35 0.34 0.30 0.10 0.30 0.34 0.91 1.00 0.42 0.33 0.31 0.39 0.72 0.75 0.60 -0.19 -0.17 -0.12 -0.17 -0.22 -0.20 -0.19 -0.17 -0.06 -0.21 -0.02 -0.06 -0.15 -0.15 0.28 0.38 0.39 0.26 0.43 0.20 0.24 0.26 0.33 0.41 0.41 0.18 0.28 0.35 0.38 0.45 0.28 -0.39 0.18 -0.07 0.33
Silver 0.23 0.20 0.24 0.29 0.17 0.02 0.18 0.20 0.21 0.17 0.18 0.10 0.07 0.08 0.29 0.29 0.26 0.08 0.24 0.28 0.45 0.42 1.00 0.78 0.44 0.51 0.37 0.37 0.29 -0.01 0.02 0.04 0.01 -0.01 0.01 0.01 0.00 0.00 0.00 -0.01 0.06 -0.01 0.00 0.09 0.13 0.13 0.17 0.18 0.04 0.11 0.08 0.23 0.15 0.19 0.12 0.40 0.43 0.40 0.43 0.37 -0.39 0.35 0.14 0.37
Gold 0.18 0.16 0.17 0.23 0.12 0.01 0.13 0.15 0.18 0.13 0.13 0.06 0.02 0.07 0.26 0.25 0.23 0.05 0.19 0.23 0.36 0.33 0.78 1.00 0.43 0.44 0.29 0.30 0.23 0.10 0.12 0.12 0.12 0.11 0.12 0.12 0.10 0.03 0.12 -0.01 0.10 0.07 0.08 -0.02 -0.02 -0.02 0.06 0.04 -0.04 0.01 -0.03 0.14 0.00 0.07 0.05 0.42 0.41 0.35 0.37 0.36 -0.34 0.41 0.23 0.36
Platinum 0.13 0.12 0.17 0.20 0.12 0.05 0.12 0.13 0.13 0.10 0.12 0.06 0.03 0.04 0.20 0.20 0.18 0.14 0.18 0.21 0.31 0.31 0.44 0.43 1.00 0.46 0.30 0.27 0.23 -0.08 -0.06 -0.05 -0.06 -0.09 -0.09 -0.08 -0.06 -0.02 -0.07 0.00 -0.01 -0.07 -0.06 0.12 0.14 0.14 0.15 0.16 0.08 0.13 0.11 0.20 0.16 0.18 0.13 0.24 0.28 0.29 0.33 0.23 -0.27 0.20 0.03 0.27
Palladium 0.17 0.15 0.21 0.24 0.15 0.04 0.16 0.17 0.14 0.15 0.15 0.07 0.06 0.06 0.24 0.24 0.21 0.15 0.21 0.25 0.39 0.39 0.51 0.44 0.46 1.00 0.36 0.36 0.29 -0.11 -0.08 -0.05 -0.09 -0.10 -0.08 -0.06 -0.08 -0.04 -0.09 -0.02 0.00 -0.06 -0.04 0.19 0.21 0.22 0.18 0.26 0.13 0.20 0.17 0.27 0.23 0.27 0.15 0.28 0.32 0.32 0.36 0.25 -0.33 0.22 0.03 0.31
Aluminium 0.20 0.17 0.23 0.27 0.16 0.05 0.19 0.17 0.16 0.19 0.15 0.10 0.10 0.09 0.30 0.29 0.25 0.10 0.25 0.30 0.67 0.72 0.37 0.29 0.30 0.36 1.00 0.68 0.53 -0.16 -0.13 -0.10 -0.14 -0.17 -0.16 -0.15 -0.15 -0.05 -0.16 -0.04 -0.04 -0.13 -0.12 0.23 0.30 0.31 0.18 0.33 0.17 0.20 0.22 0.28 0.32 0.32 0.15 0.27 0.32 0.31 0.36 0.26 -0.34 0.20 -0.04 0.31
Zinc 0.18 0.17 0.21 0.25 0.15 0.07 0.18 0.17 0.16 0.18 0.14 0.07 0.08 0.06 0.27 0.27 0.24 0.08 0.25 0.27 0.68 0.75 0.37 0.30 0.27 0.36 0.68 1.00 0.57 -0.14 -0.14 -0.11 -0.13 -0.16 -0.16 -0.16 -0.14 -0.05 -0.16 -0.03 -0.06 -0.13 -0.12 0.21 0.29 0.30 0.22 0.35 0.15 0.19 0.20 0.26 0.33 0.33 0.16 0.24 0.30 0.31 0.37 0.23 -0.33 0.15 -0.06 0.27
Nickel 0.16 0.14 0.18 0.22 0.13 0.06 0.16 0.15 0.12 0.18 0.12 0.08 0.09 0.05 0.25 0.25 0.21 0.07 0.21 0.26 0.57 0.60 0.29 0.23 0.23 0.29 0.53 0.57 1.00 -0.13 -0.12 -0.09 -0.12 -0.16 -0.13 -0.12 -0.12 -0.04 -0.15 -0.03 -0.05 -0.10 -0.09 0.20 0.26 0.27 0.18 0.30 0.14 0.17 0.19 0.23 0.29 0.27 0.13 0.19 0.24 0.26 0.31 0.18 -0.28 0.13 -0.06 0.23
Treasury Bonds -0.08 -0.10 -0.12 -0.14 -0.08 -0.04 -0.07 -0.06 -0.08 -0.10 -0.09 -0.05 -0.10 -0.02 -0.20 -0.17 -0.14 -0.03 -0.11 -0.18 -0.20 -0.19 -0.01 0.10 -0.08 -0.11 -0.16 -0.14 -0.13 1.00 0.85 0.66 0.93 0.61 0.56 0.46 0.81 0.09 0.54 0.04 0.54 0.33 0.33 -0.35 -0.35 -0.35 -0.12 -0.31 -0.29 -0.31 -0.33 -0.28 -0.34 -0.28 -0.09 0.04 -0.05 -0.09 -0.13 -0.01 0.17 0.15 0.31 -0.09
5 yr T-Notes US -0.07 -0.09 -0.11 -0.12 -0.08 -0.05 -0.06 -0.05 -0.06 -0.10 -0.09 -0.03 -0.11 -0.02 -0.14 -0.13 -0.10 -0.01 -0.07 -0.15 -0.17 -0.17 0.02 0.12 -0.06 -0.08 -0.13 -0.14 -0.12 0.85 1.00 0.90 0.96 0.55 0.57 0.52 0.77 0.09 0.49 0.04 0.76 0.37 0.40 -0.35 -0.35 -0.34 -0.13 -0.30 -0.31 -0.27 -0.33 -0.26 -0.32 -0.25 -0.08 0.11 0.00 -0.05 -0.09 0.04 0.11 0.21 0.34 -0.03
2 yr T-Note US -0.05 -0.07 -0.09 -0.09 -0.07 -0.04 -0.04 -0.03 -0.02 -0.08 -0.07 -0.02 -0.09 -0.02 -0.10 -0.09 -0.08 0.00 -0.04 -0.10 -0.13 -0.12 0.04 0.12 -0.05 -0.05 -0.10 -0.11 -0.09 0.66 0.90 1.00 0.81 0.45 0.50 0.51 0.64 0.07 0.39 0.04 0.85 0.38 0.42 -0.33 -0.31 -0.30 -0.12 -0.27 -0.30 -0.22 -0.30 -0.23 -0.28 -0.21 -0.07 0.15 0.05 -0.02 -0.06 0.08 0.06 0.22 0.31 0.02
10yr T-Notes -0.07 -0.09 -0.11 -0.12 -0.08 -0.04 -0.06 -0.05 -0.07 -0.10 -0.08 -0.04 -0.11 -0.02 -0.17 -0.14 -0.11 -0.02 -0.09 -0.16 -0.18 -0.17 0.01 0.12 -0.06 -0.09 -0.14 -0.13 -0.12 0.93 0.96 0.81 1.00 0.59 0.59 0.51 0.82 0.10 0.53 0.04 0.68 0.36 0.38 -0.35 -0.35 -0.35 -0.12 -0.30 -0.30 -0.28 -0.32 -0.27 -0.33 -0.26 -0.08 0.09 -0.02 -0.06 -0.10 0.02 0.13 0.20 0.34 -0.06
Euro-Bund -0.08 -0.07 -0.11 -0.11 -0.07 -0.04 -0.09 -0.06 -0.10 -0.09 -0.06 -0.06 -0.08 0.00 -0.15 -0.13 -0.10 -0.08 -0.10 -0.15 -0.20 -0.22 -0.01 0.11 -0.09 -0.10 -0.17 -0.16 -0.16 0.61 0.55 0.45 0.59 1.00 0.93 0.76 0.62 0.14 0.81 0.08 0.34 0.49 0.59 -0.30 -0.43 -0.46 -0.16 -0.40 -0.23 -0.27 -0.29 -0.25 -0.45 -0.36 -0.12 -0.02 -0.08 -0.09 -0.13 -0.04 0.17 0.11 0.33 -0.11
Euro-Bobl -0.06 -0.06 -0.10 -0.10 -0.07 -0.03 -0.10 -0.06 -0.09 -0.09 -0.07 -0.06 -0.08 0.00 -0.14 -0.12 -0.09 -0.06 -0.09 -0.15 -0.19 -0.20 0.01 0.12 -0.09 -0.08 -0.16 -0.16 -0.13 0.56 0.57 0.50 0.59 0.93 1.00 0.91 0.59 0.14 0.74 0.08 0.41 0.56 0.73 -0.31 -0.43 -0.46 -0.16 -0.41 -0.25 -0.26 -0.29 -0.25 -0.45 -0.35 -0.12 0.00 -0.05 -0.07 -0.11 -0.02 0.14 0.15 0.33 -0.09
Euro-Schatz -0.08 -0.06 -0.10 -0.11 -0.07 -0.02 -0.09 -0.06 -0.06 -0.10 -0.09 -0.06 -0.07 0.01 -0.12 -0.10 -0.08 -0.05 -0.07 -0.15 -0.17 -0.19 0.01 0.12 -0.08 -0.06 -0.15 -0.16 -0.12 0.46 0.52 0.51 0.51 0.76 0.91 1.00 0.51 0.12 0.59 0.07 0.45 0.59 0.81 -0.29 -0.41 -0.43 -0.16 -0.39 -0.24 -0.22 -0.26 -0.24 -0.42 -0.32 -0.13 0.02 -0.02 -0.06 -0.11 0.00 0.11 0.17 0.30 -0.06
Canadian Bond -0.07 -0.07 -0.09 -0.10 -0.06 -0.04 -0.05 -0.05 -0.07 -0.08 -0.05 -0.07 -0.09 -0.02 -0.15 -0.13 -0.11 -0.02 -0.09 -0.15 -0.17 -0.17 0.00 0.10 -0.06 -0.08 -0.15 -0.14 -0.12 0.81 0.77 0.64 0.82 0.62 0.59 0.51 1.00 0.10 0.55 0.05 0.54 0.34 0.38 -0.34 -0.35 -0.35 -0.11 -0.30 -0.29 -0.29 -0.32 -0.27 -0.34 -0.27 -0.09 0.06 -0.02 -0.07 -0.09 0.00 0.17 0.17 0.30 -0.06
JGB Japan -0.03 -0.02 -0.02 -0.02 -0.02 0.01 0.00 0.00 -0.01 -0.02 -0.02 -0.03 0.01 -0.01 -0.02 -0.02 -0.01 -0.14 -0.03 -0.02 -0.06 -0.06 0.00 0.03 -0.02 -0.04 -0.05 -0.05 -0.04 0.09 0.09 0.07 0.10 0.14 0.14 0.12 0.10 1.00 0.14 0.38 0.06 0.15 0.12 -0.06 -0.09 -0.09 -0.19 -0.10 -0.05 -0.04 -0.06 -0.06 -0.10 -0.11 -0.35 0.03 0.01 -0.06 -0.08 0.00 0.03 0.06 0.08 0.00
Gilts UK -0.06 -0.06 -0.12 -0.13 -0.08 -0.05 -0.08 -0.05 -0.09 -0.08 -0.07 -0.06 -0.10 -0.01 -0.14 -0.12 -0.09 -0.11 -0.11 -0.14 -0.19 -0.21 0.00 0.12 -0.07 -0.09 -0.16 -0.16 -0.15 0.54 0.49 0.39 0.53 0.81 0.74 0.59 0.55 0.14 1.00 0.07 0.28 0.44 0.49 -0.27 -0.38 -0.40 -0.18 -0.37 -0.20 -0.24 -0.26 -0.24 -0.41 -0.33 -0.16 0.02 -0.05 -0.08 -0.12 -0.10 0.16 0.12 0.33 -0.08
Euroyen -0.01 -0.01 -0.02 0.00 -0.01 0.00 0.00 -0.01 -0.03 0.01 -0.01 -0.02 -0.01 0.00 -0.03 -0.01 -0.02 -0.05 -0.01 -0.05 -0.03 -0.02 -0.01 -0.01 0.00 -0.02 -0.04 -0.03 -0.03 0.04 0.04 0.04 0.04 0.08 0.08 0.07 0.05 0.38 0.07 1.00 0.17 0.30 0.25 -0.06 -0.06 -0.06 -0.09 -0.07 -0.05 -0.04 -0.06 -0.07 -0.06 -0.08 -0.17 0.00 0.00 -0.04 -0.06 -0.02 0.03 0.01 0.00 -0.03
Eurodollar -0.01 -0.04 -0.05 -0.04 -0.04 -0.05 -0.01 -0.01 -0.01 -0.06 -0.05 -0.01 -0.07 -0.01 -0.05 -0.03 -0.03 0.02 -0.01 -0.06 -0.06 -0.06 0.06 0.10 -0.01 0.00 -0.04 -0.06 -0.05 0.54 0.76 0.85 0.68 0.34 0.41 0.45 0.54 0.06 0.28 0.17 1.00 0.41 0.48 -0.23 -0.23 -0.21 -0.06 -0.18 -0.23 -0.12 -0.21 -0.17 -0.19 -0.10 -0.03 0.20 0.11 0.03 0.02 0.13 -0.01 0.24 0.26 0.07
Euroswiss -0.05 -0.06 -0.09 -0.08 -0.07 -0.05 -0.04 -0.05 -0.05 -0.07 -0.06 -0.02 -0.08 -0.01 -0.08 -0.08 -0.06 -0.04 -0.06 -0.11 -0.14 -0.15 -0.01 0.07 -0.07 -0.06 -0.13 -0.13 -0.10 0.33 0.37 0.38 0.36 0.49 0.56 0.59 0.34 0.15 0.44 0.30 0.41 1.00 0.69 -0.24 -0.33 -0.33 -0.16 -0.32 -0.20 -0.18 -0.22 -0.20 -0.35 -0.24 -0.17 0.00 -0.05 -0.08 -0.11 -0.03 0.12 0.13 0.21 -0.06
Euribor -0.07 -0.06 -0.09 -0.08 -0.07 -0.04 -0.06 -0.04 -0.05 -0.07 -0.09 -0.04 -0.06 0.00 -0.08 -0.07 -0.05 -0.02 -0.04 -0.12 -0.14 -0.15 0.00 0.08 -0.06 -0.04 -0.12 -0.12 -0.09 0.33 0.40 0.42 0.38 0.59 0.73 0.81 0.38 0.12 0.49 0.25 0.48 0.69 1.00 -0.20 -0.31 -0.32 -0.14 -0.31 -0.18 -0.14 -0.18 -0.19 -0.33 -0.21 -0.15 0.02 -0.01 -0.03 -0.06 0.01 0.06 0.14 0.22 -0.03
SP500 E-Mini 0.14 0.13 0.15 0.20 0.10 0.04 0.11 0.12 0.10 0.17 0.09 0.08 0.12 0.04 0.23 0.23 0.19 0.04 0.13 0.26 0.28 0.28 0.09 -0.02 0.12 0.19 0.23 0.21 0.20 -0.35 -0.35 -0.33 -0.35 -0.30 -0.31 -0.29 -0.34 -0.06 -0.27 -0.06 -0.23 -0.24 -0.20 1.00 0.63 0.61 0.25 0.56 0.84 0.76 0.93 0.73 0.58 0.49 0.16 0.09 0.17 0.26 0.31 0.12 -0.28 -0.06 -0.22 0.22
DAX 30 0.13 0.13 0.17 0.20 0.13 0.04 0.12 0.13 0.11 0.16 0.10 0.08 0.14 0.04 0.19 0.18 0.15 0.07 0.15 0.22 0.36 0.38 0.13 -0.02 0.14 0.21 0.30 0.29 0.26 -0.35 -0.35 -0.31 -0.35 -0.43 -0.43 -0.41 -0.35 -0.09 -0.38 -0.06 -0.23 -0.33 -0.31 0.63 1.00 0.94 0.35 0.81 0.52 0.42 0.59 0.51 0.88 0.64 0.26 0.04 0.16 0.26 0.32 0.10 -0.29 -0.09 -0.26 0.23
Eurostoxx 0.13 0.13 0.17 0.20 0.13 0.06 0.13 0.13 0.12 0.17 0.10 0.09 0.14 0.03 0.20 0.19 0.15 0.09 0.16 0.23 0.37 0.39 0.13 -0.02 0.14 0.22 0.31 0.30 0.27 -0.35 -0.34 -0.30 -0.35 -0.46 -0.46 -0.43 -0.35 -0.09 -0.40 -0.06 -0.21 -0.33 -0.32 0.61 0.94 1.00 0.35 0.86 0.48 0.41 0.57 0.51 0.94 0.65 0.26 0.05 0.19 0.27 0.33 0.11 -0.31 -0.09 -0.28 0.23
Hang Seng 0.08 0.06 0.13 0.19 0.09 0.01 0.08 0.11 0.12 0.09 0.11 0.07 0.08 0.03 0.15 0.16 0.13 0.23 0.14 0.18 0.25 0.26 0.17 0.06 0.15 0.18 0.18 0.22 0.18 -0.12 -0.13 -0.12 -0.12 -0.16 -0.16 -0.16 -0.11 -0.19 -0.18 -0.09 -0.06 -0.16 -0.14 0.25 0.35 0.35 1.00 0.40 0.19 0.19 0.23 0.27 0.38 0.34 0.56 0.10 0.19 0.27 0.34 0.15 -0.21 0.00 -0.15 0.23
FTSE 100 UK 0.16 0.15 0.20 0.25 0.15 0.06 0.15 0.13 0.11 0.18 0.13 0.10 0.14 0.04 0.25 0.25 0.20 0.11 0.21 0.28 0.40 0.43 0.18 0.04 0.16 0.26 0.33 0.35 0.30 -0.31 -0.30 -0.27 -0.30 -0.40 -0.41 -0.39 -0.30 -0.10 -0.37 -0.07 -0.18 -0.32 -0.31 0.56 0.81 0.86 0.40 1.00 0.41 0.42 0.52 0.51 0.89 0.68 0.31 0.10 0.24 0.33 0.40 0.10 -0.34 -0.06 -0.28 0.26
Nasdaq 100 Mini 0.10 0.10 0.11 0.14 0.08 0.01 0.08 0.07 0.06 0.13 0.07 0.06 0.12 0.02 0.13 0.13 0.11 0.01 0.08 0.16 0.21 0.20 0.04 -0.04 0.08 0.13 0.17 0.15 0.14 -0.29 -0.31 -0.30 -0.30 -0.23 -0.25 -0.24 -0.29 -0.05 -0.20 -0.05 -0.23 -0.20 -0.18 0.84 0.52 0.48 0.19 0.41 1.00 0.55 0.71 0.60 0.44 0.34 0.12 0.03 0.09 0.19 0.21 0.06 -0.19 -0.08 -0.15 0.15
Russel 2000 E-Mini 0.12 0.13 0.14 0.19 0.09 0.02 0.11 0.12 0.11 0.16 0.07 0.06 0.10 0.03 0.23 0.24 0.21 0.04 0.15 0.26 0.23 0.24 0.11 0.01 0.13 0.20 0.20 0.19 0.17 -0.31 -0.27 -0.22 -0.28 -0.27 -0.26 -0.22 -0.29 -0.04 -0.24 -0.04 -0.12 -0.18 -0.14 0.76 0.42 0.41 0.19 0.42 0.55 1.00 0.75 0.60 0.43 0.50 0.09 0.15 0.20 0.27 0.29 0.16 -0.28 0.00 -0.21 0.26
Dow Jones 0.11 0.11 0.13 0.18 0.09 0.03 0.08 0.11 0.09 0.15 0.07 0.08 0.11 0.03 0.19 0.19 0.16 0.03 0.11 0.23 0.26 0.26 0.08 -0.03 0.11 0.17 0.22 0.20 0.19 -0.33 -0.33 -0.30 -0.32 -0.29 -0.29 -0.26 -0.32 -0.06 -0.26 -0.06 -0.21 -0.22 -0.18 0.93 0.59 0.57 0.23 0.52 0.71 0.75 1.00 0.66 0.54 0.49 0.14 0.08 0.16 0.24 0.28 0.11 -0.26 -0.06 -0.22 0.20
TSE Toronto 0.18 0.17 0.20 0.24 0.15 0.05 0.13 0.14 0.13 0.18 0.16 0.10 0.10 0.10 0.33 0.33 0.28 0.08 0.19 0.35 0.33 0.33 0.23 0.14 0.20 0.27 0.28 0.26 0.23 -0.28 -0.26 -0.23 -0.27 -0.25 -0.25 -0.24 -0.27 -0.06 -0.24 -0.07 -0.17 -0.20 -0.19 0.73 0.51 0.51 0.27 0.51 0.60 0.60 0.66 1.00 0.51 0.44 0.22 0.13 0.22 0.27 0.32 0.18 -0.24 0.01 -0.16 0.24
CAC 40 France 0.13 0.13 0.18 0.22 0.13 0.06 0.13 0.13 0.13 0.17 0.11 0.08 0.14 0.04 0.22 0.22 0.18 0.08 0.17 0.25 0.38 0.41 0.15 0.00 0.16 0.23 0.32 0.33 0.29 -0.34 -0.32 -0.28 -0.33 -0.45 -0.45 -0.42 -0.34 -0.10 -0.41 -0.06 -0.19 -0.35 -0.33 0.58 0.88 0.94 0.38 0.89 0.44 0.43 0.54 0.51 1.00 0.69 0.30 0.07 0.21 0.30 0.36 0.13 -0.33 -0.08 -0.28 0.25
OMX 30 Stockholm 0.15 0.13 0.20 0.24 0.15 0.04 0.14 0.14 0.14 0.17 0.13 0.11 0.12 0.04 0.25 0.25 0.21 0.11 0.21 0.28 0.38 0.41 0.19 0.07 0.18 0.27 0.32 0.33 0.27 -0.28 -0.25 -0.21 -0.26 -0.36 -0.35 -0.32 -0.27 -0.11 -0.33 -0.08 -0.10 -0.24 -0.21 0.49 0.64 0.65 0.34 0.68 0.34 0.50 0.49 0.44 0.69 1.00 0.26 0.21 0.32 0.36 0.42 0.22 -0.38 0.04 -0.25 0.34
NIKKEI 225 0.05 0.05 0.08 0.12 0.07 0.02 0.08 0.07 0.07 0.05 0.06 0.07 0.04 0.03 0.10 0.12 0.10 0.33 0.09 0.13 0.18 0.18 0.12 0.05 0.13 0.15 0.15 0.16 0.13 -0.09 -0.08 -0.07 -0.08 -0.12 -0.12 -0.13 -0.09 -0.35 -0.16 -0.17 -0.03 -0.17 -0.15 0.16 0.26 0.26 0.56 0.31 0.12 0.09 0.14 0.22 0.30 0.26 1.00 0.06 0.12 0.20 0.26 0.11 -0.15 -0.01 -0.18 0.11
Euro 0.17 0.16 0.17 0.20 0.13 0.00 0.13 0.15 0.21 0.17 0.09 0.06 0.05 0.07 0.23 0.23 0.20 0.05 0.20 0.19 0.29 0.28 0.40 0.42 0.24 0.28 0.27 0.24 0.19 0.04 0.11 0.15 0.09 -0.02 0.00 0.02 0.06 0.03 0.02 0.00 0.20 0.00 0.02 0.09 0.04 0.05 0.10 0.10 0.03 0.15 0.08 0.13 0.07 0.21 0.06 1.00 0.78 0.56 0.58 0.66 -0.48 0.76 0.29 0.57
Norwegian Krone 0.20 0.20 0.22 0.26 0.16 0.01 0.15 0.17 0.22 0.20 0.13 0.05 0.08 0.07 0.32 0.31 0.26 0.12 0.29 0.28 0.35 0.35 0.43 0.41 0.28 0.32 0.32 0.30 0.24 -0.05 0.00 0.05 -0.02 -0.08 -0.05 -0.02 -0.02 0.01 -0.05 0.00 0.11 -0.05 -0.01 0.17 0.16 0.19 0.19 0.24 0.09 0.20 0.16 0.22 0.21 0.32 0.12 0.78 1.00 0.57 0.60 0.61 -0.52 0.60 0.17 0.56
New Zealand Dollar 0.18 0.18 0.19 0.24 0.15 0.01 0.17 0.19 0.22 0.17 0.11 0.07 0.09 0.07 0.25 0.26 0.22 0.11 0.23 0.23 0.38 0.38 0.40 0.35 0.29 0.32 0.31 0.31 0.26 -0.09 -0.05 -0.02 -0.06 -0.09 -0.07 -0.06 -0.07 -0.06 -0.08 -0.04 0.03 -0.08 -0.03 0.26 0.26 0.27 0.27 0.33 0.19 0.27 0.24 0.27 0.30 0.36 0.20 0.56 0.57 1.00 0.82 0.54 -0.56 0.40 0.07 0.56
Australian Dollar 0.21 0.20 0.25 0.30 0.19 0.02 0.20 0.20 0.23 0.21 0.15 0.09 0.11 0.09 0.32 0.32 0.28 0.12 0.27 0.31 0.45 0.45 0.43 0.37 0.33 0.36 0.36 0.37 0.31 -0.13 -0.09 -0.06 -0.10 -0.13 -0.11 -0.11 -0.09 -0.08 -0.12 -0.06 0.02 -0.11 -0.06 0.31 0.32 0.33 0.34 0.40 0.21 0.29 0.28 0.32 0.36 0.42 0.26 0.58 0.60 0.82 1.00 0.54 -0.62 0.40 0.06 0.59
British Pound 0.16 0.15 0.17 0.21 0.12 0.02 0.13 0.15 0.24 0.15 0.10 0.03 0.08 0.06 0.22 0.24 0.20 0.10 0.20 0.21 0.29 0.28 0.37 0.36 0.23 0.25 0.26 0.23 0.18 -0.01 0.04 0.08 0.02 -0.04 -0.02 0.00 0.00 0.00 -0.10 -0.02 0.13 -0.03 0.01 0.12 0.10 0.11 0.15 0.10 0.06 0.16 0.11 0.18 0.13 0.22 0.11 0.66 0.61 0.54 0.54 1.00 -0.46 0.51 0.18 0.48
Canadian Dollar -0.20 -0.20 -0.22 -0.28 -0.17 -0.03 -0.15 -0.17 -0.20 -0.20 -0.06 -0.09 -0.09 -0.10 -0.34 -0.34 -0.30 -0.11 -0.31 -0.31 -0.38 -0.39 -0.39 -0.34 -0.27 -0.33 -0.34 -0.33 -0.28 0.17 0.11 0.06 0.13 0.17 0.14 0.11 0.17 0.03 0.16 0.03 -0.01 0.12 0.06 -0.28 -0.29 -0.31 -0.21 -0.34 -0.19 -0.28 -0.26 -0.24 -0.33 -0.38 -0.15 -0.48 -0.52 -0.56 -0.62 -0.46 1.00 -0.33 -0.03 -0.48
Swiss Franc 0.11 0.12 0.11 0.13 0.08 -0.02 0.09 0.08 0.14 0.11 0.05 0.03 0.01 0.06 0.13 0.14 0.13 0.04 0.16 0.10 0.20 0.18 0.35 0.41 0.20 0.22 0.20 0.15 0.13 0.15 0.21 0.22 0.20 0.11 0.15 0.17 0.17 0.06 0.12 0.01 0.24 0.13 0.14 -0.06 -0.09 -0.09 0.00 -0.06 -0.08 0.00 -0.06 0.01 -0.08 0.04 -0.01 0.76 0.60 0.40 0.40 0.51 -0.33 1.00 0.39 0.45
Japanese Yen -0.02 0.00 -0.01 -0.05 0.01 -0.03 -0.04 0.00 0.01 -0.01 -0.02 -0.03 -0.07 0.01 -0.06 -0.05 -0.03 -0.13 -0.03 -0.08 -0.08 -0.07 0.14 0.23 0.03 0.03 -0.04 -0.06 -0.06 0.31 0.34 0.31 0.34 0.33 0.33 0.30 0.30 0.08 0.33 0.00 0.26 0.21 0.22 -0.22 -0.26 -0.28 -0.15 -0.28 -0.15 -0.21 -0.22 -0.16 -0.28 -0.25 -0.18 0.29 0.17 0.07 0.06 0.18 -0.03 0.39 1.00 0.27
Singapore Dollar 0.17 0.16 0.21 0.23 0.16 0.01 0.16 0.16 0.19 0.17 0.12 0.07 0.09 0.05 0.25 0.24 0.21 0.05 0.21 0.22 0.32 0.33 0.37 0.36 0.27 0.31 0.31 0.27 0.23 -0.09 -0.03 0.02 -0.06 -0.11 -0.09 -0.06 -0.06 0.00 -0.08 -0.03 0.07 -0.06 -0.03 0.22 0.23 0.23 0.23 0.26 0.15 0.26 0.20 0.24 0.25 0.34 0.11 0.57 0.56 0.56 0.59 0.48 -0.48 0.45 0.27 1.00

We see quite high correlations among some of the futures. Does it make sense? Why? Do you see some negative correlations? Do those make sense?

Given such high correlations, we can try to see whether there are some “principal components” (see reading on dimensionality reduction). This analysis can also indicate whether all futures (the global economy!) are driven by some common “factors” (let’s call them “risk factors”).

Eigenvalue Pct of explained variance Cumulative pct of explained variance
comp 1 14.04 21.94 21.94
comp 2 7.84 12.25 34.19
comp 3 3.52 5.50 39.69
comp 4 3.05 4.77 44.46
comp 5 2.63 4.11 48.57
comp 6 2.38 3.72 52.29
comp 7 2.14 3.34 55.64
comp 8 1.70 2.65 58.29
comp 9 1.46 2.28 60.57
comp 10 1.31 2.04 62.61
comp 11 1.18 1.84 64.45
comp 12 1.14 1.79 66.24
comp 13 1.00 1.56 67.80
comp 14 1.00 1.56 69.36
comp 15 0.98 1.53 70.89
comp 16 0.94 1.47 72.37
comp 17 0.90 1.41 73.78
comp 18 0.87 1.36 75.14
comp 19 0.84 1.32 76.46
comp 20 0.82 1.29 77.75
comp 21 0.79 1.23 78.98
comp 22 0.78 1.22 80.20
comp 23 0.76 1.19 81.39
comp 24 0.70 1.09 82.48
comp 25 0.63 0.98 83.46
comp 26 0.60 0.93 84.40
comp 27 0.59 0.92 85.32
comp 28 0.55 0.86 86.18
comp 29 0.53 0.83 87.01
comp 30 0.51 0.80 87.81
comp 31 0.50 0.78 88.59
comp 32 0.49 0.76 89.35
comp 33 0.45 0.70 90.06
comp 34 0.43 0.67 90.73
comp 35 0.39 0.62 91.34
comp 36 0.38 0.60 91.94
comp 37 0.37 0.57 92.52
comp 38 0.36 0.56 93.07
comp 39 0.35 0.55 93.62
comp 40 0.34 0.53 94.15
comp 41 0.33 0.51 94.67
comp 42 0.32 0.51 95.18
comp 43 0.31 0.48 95.65
comp 44 0.30 0.46 96.12
comp 45 0.29 0.45 96.56
comp 46 0.23 0.36 96.92
comp 47 0.21 0.32 97.24
comp 48 0.20 0.31 97.56
comp 49 0.19 0.30 97.85
comp 50 0.18 0.27 98.13
comp 51 0.16 0.24 98.37
comp 52 0.15 0.24 98.61
comp 53 0.14 0.23 98.84
comp 54 0.13 0.21 99.04
comp 55 0.11 0.16 99.21
comp 56 0.09 0.14 99.35
comp 57 0.09 0.13 99.49
comp 58 0.08 0.13 99.62
comp 59 0.08 0.12 99.74
comp 60 0.06 0.09 99.83
comp 61 0.04 0.06 99.89
comp 62 0.03 0.05 99.94
comp 63 0.02 0.03 99.97
comp 64 0.02 0.03 100.00

Here is the scree plot (see Sessions 3-4 readings):

Let’s now see how the 20 first (rotated) principal components look like. Let’s also use the rotated factors (note that these are not really the “principal component”, as explained in the reading on dimensionality reduction) and not show any numbers less than 0.3 in absolute value, to avoid cluttering.

comp 1 comp 2 comp 3 comp 4 comp 5 comp 6 comp 7 comp 8 comp 9 comp 10 comp 11 comp 12 comp 13 comp 14 comp 15 comp 16 comp 17 comp 18 comp 19 comp 20
5 yr T-Notes US 0.93
10yr T-Notes 0.93
Treasury Bonds 0.86
2 yr T-Note US 0.85
Canadian Bond 0.79
Eurodollar 0.74 -0.45
Euro-Bund 0.43 0.67 0.44
Euro-Bobl 0.41 0.79
Gilts UK 0.39 0.55 0.47
Euro-Schatz 0.34 0.83
Japanese Yen 0.33 0.36
Euribor 0.87
Euroswiss 0.72
Swiss Franc 0.74
Euro 0.87
Gold 0.34 0.74
Canadian Dollar -0.61
JGB Japan 0.75
British Pound 0.74
Silver 0.32 0.73
Norwegian Krone 0.79
Kerosene 0.87
Sugar 0.67
Coffee 0.64
Orange Juice 0.98
Natural Gas 0.91
Euroyen 0.83
Singapore Dollar 0.70
Corn 0.72
Canola 0.77
NIKKEI 225 0.78
Soybean Meal 0.82
Lean Hoggs 0.99
Gas Oil 0.65 0.40
Platinum 0.69
Soybeans 0.90
Cocoa 0.87
Heating Oil 0.89
Hang Seng 0.78
New Zealand Dollar 0.73
Wheat 0.59 0.36
Soybean Oil 0.74
Brent Crude 0.90
Palladium 0.66
Aluminium 0.77
Zinc 0.81
Nickel 0.72
Gasoline 0.72
Copper LDN 0.84
Australian Dollar 0.72
Cotton 0.73
Lumber 0.98
Crude Oil 0.88
Copper NY 0.79
TSE Toronto 0.71
OMX 30 Stockholm 0.62
FTSE 100 UK 0.81
Russel 2000 E-Mini 0.79
CAC 40 France 0.85
DAX 30 0.82 0.34
Eurostoxx 0.85 0.30
Nasdaq 100 Mini 0.80
Dow Jones 0.85
SP500 E-Mini 0.30 0.89

Questions

  1. How many principal components (“factors”) do we need to explain at least 50% of the variance in this data?
  2. What are the highest weights (in absolute value) of the first principal component portfolio above on the 64 futures?
  3. Can we interpret the first 10 components? How would you call these factors?
  4. Can you now generate the principal components and scree plot using only: a) the pre-crisis bull market years (e.g. only using the data between November 1, 2002, and October 1, 2007)? b) the financial crisis years (e.g. only using the data between October 1, 2007 and March 1, 2009), (Hint: you can select subsets of the data using for example the command crisis_data = futures_data[ as.Date(rownames(futures_data)) > "2007-10-01" & as.Date(rownames(futures_data)) < "2009-03-01" , ])
  5. Based on your analysis in question 3, please discuss any differences you observe about the futures returns during bull and bear markets. What implications may these results have? What do the results imply about how assets are correlated during bear years compared to bull years?

Answer 1:

i <- 0
for (x in Variance_Explained_Table[,3]) {
  i <- i+1
    if (x > 50) {
      break
  }
}
i

[1] 6

Answer 2:

for (x in which(show_data[,"comp 1"] >= 0.0)) {
  name <- rownames(show_data)[x]
  cat(name, " max: ", round(max(futures_data[,name]),3), "<br>")
}

5 yr T-Notes US max: 0.019
10yr T-Notes max: 0.036
Treasury Bonds max: 0.041
2 yr T-Note US max: 0.008
Canadian Bond max: 0.017
Eurodollar max: 0.005
Euro-Bund max: 0.02
Euro-Bobl max: 0.01
Gilts UK max: 0.024
Euro-Schatz max: 0.006

Answer 3:

Global factors, such as USA performance (1st) or precious metals prices (9th). See below.

for (x in 1:10) {
  y <- which(show_data[,x]>.5)
  a <- rownames(show_data)[y]

  print(toString(a))
}

[1] “5 yr T-Notes US, 10yr T-Notes, Treasury Bonds, 2 yr T-Note US, Canadian Bond, Eurodollar” [1] “Swiss Franc, Euro, British Pound, Norwegian Krone, Singapore Dollar, New Zealand Dollar, Australian Dollar” [1] “OMX 30 Stockholm, FTSE 100 UK, CAC 40 France, DAX 30, Eurostoxx” [1] “TSE Toronto, Russel 2000 E-Mini, Nasdaq 100 Mini, Dow Jones, SP500 E-Mini” [1] “Euro-Bund, Euro-Bobl, Gilts UK, Euro-Schatz, Euribor, Euroswiss” [1] “Gas Oil, Heating Oil, Brent Crude, Gasoline, Crude Oil” [1] “Aluminium, Zinc, Nickel, Copper LDN, Copper NY” [1] “Corn, Canola, Soybean Meal, Soybeans, Wheat, Soybean Oil” [1] “Gold, Silver, Platinum, Palladium” [1] “NIKKEI 225, Hang Seng”

Answer 4:

Pre-crisis

Eigenvalue Pct of explained variance Cumulative pct of explained variance
comp 1 11.35 17.74 17.74
comp 2 7.59 11.85 29.59
comp 3 3.87 6.04 35.64
comp 4 3.54 5.53 41.17
comp 5 3.22 5.03 46.20
comp 6 2.66 4.15 50.35
comp 7 2.16 3.37 53.72
comp 8 1.52 2.38 56.10
comp 9 1.43 2.23 58.33
comp 10 1.33 2.08 60.40
comp 11 1.24 1.93 62.33
comp 12 1.15 1.80 64.13
comp 13 1.07 1.68 65.81
comp 14 1.05 1.64 67.45
comp 15 1.01 1.57 69.02
comp 16 0.99 1.55 70.57
comp 17 0.97 1.51 72.08
comp 18 0.93 1.46 73.54
comp 19 0.91 1.43 74.96
comp 20 0.90 1.40 76.36
comp 21 0.86 1.34 77.70
comp 22 0.84 1.32 79.02
comp 23 0.82 1.28 80.30
comp 24 0.75 1.18 81.48
comp 25 0.74 1.15 82.63
comp 26 0.73 1.14 83.77
comp 27 0.70 1.10 84.87
comp 28 0.68 1.06 85.93
comp 29 0.66 1.03 86.96
comp 30 0.60 0.93 87.89
comp 31 0.57 0.89 88.78
comp 32 0.56 0.87 89.65
comp 33 0.48 0.75 90.40
comp 34 0.45 0.71 91.11
comp 35 0.40 0.63 91.74
comp 36 0.39 0.61 92.36
comp 37 0.38 0.59 92.95
comp 38 0.38 0.59 93.54
comp 39 0.36 0.56 94.10
comp 40 0.34 0.54 94.63
comp 41 0.31 0.49 95.12
comp 42 0.31 0.48 95.60
comp 43 0.30 0.47 96.07
comp 44 0.28 0.43 96.50
comp 45 0.25 0.38 96.88
comp 46 0.23 0.36 97.24
comp 47 0.21 0.34 97.58
comp 48 0.21 0.32 97.90
comp 49 0.19 0.30 98.20
comp 50 0.17 0.27 98.47
comp 51 0.16 0.25 98.72
comp 52 0.16 0.24 98.96
comp 53 0.11 0.17 99.13
comp 54 0.09 0.15 99.28
comp 55 0.08 0.13 99.41
comp 56 0.08 0.12 99.53
comp 57 0.07 0.11 99.63
comp 58 0.05 0.09 99.72
comp 59 0.05 0.07 99.79
comp 60 0.04 0.07 99.86
comp 61 0.04 0.06 99.92
comp 62 0.03 0.04 99.97
comp 63 0.01 0.02 99.99
comp 64 0.01 0.01 100.00

comp 1 comp 2 comp 3 comp 4 comp 5 comp 6 comp 7 comp 8 comp 9 comp 10 comp 11 comp 12 comp 13 comp 14 comp 15 comp 16 comp 17 comp 18 comp 19 comp 20
5 yr T-Notes US 0.93
10yr T-Notes 0.93
2 yr T-Note US 0.90
Treasury Bonds 0.89
Eurodollar 0.85
Canadian Bond 0.82
Euro-Bund 0.45 0.79
Euro-Bobl 0.44 0.82
Euro-Schatz 0.41 0.80
Gilts UK 0.34 0.76
Euribor 0.82
Euroswiss 0.68 0.30
Swiss Franc 0.83
Euro 0.87
British Pound 0.79
Norwegian Krone 0.79
Japanese Yen 0.60 -0.33
Gold 0.46 0.60
JGB Japan -0.30 0.69
Orange Juice 0.92
Gasoline 0.41 0.49
Silver 0.36 0.30 0.65
Platinum 0.62
Heating Oil 0.93
Australian Dollar 0.76
Canadian Dollar -0.57
Natural Gas 0.56
Brent Crude 0.91
Kerosene 0.90
Corn 0.59 0.54
Soybean Meal 0.83
Crude Oil 0.92
New Zealand Dollar 0.71
Singapore Dollar 0.69
Wheat 0.39 0.73
Soybeans 0.93
Sugar 0.72
Gas Oil 0.68 0.36
Copper LDN 0.90
Nickel 0.70
Soybean Oil 0.81
Coffee 0.67
Copper NY 0.85
Aluminium 0.82
Euroyen 0.84
Russel 2000 E-Mini 0.85
Zinc 0.83
Lean Hoggs 0.97
Canola 0.80
Lumber 0.95
Hang Seng 0.78
Cotton 0.88
Cocoa -0.42 0.54
OMX 30 Stockholm 0.43 0.49
NIKKEI 225 0.81
Palladium 0.65
TSE Toronto 0.73
FTSE 100 UK 0.81
CAC 40 France 0.83
SP500 E-Mini 0.92
Dow Jones 0.87
Nasdaq 100 Mini 0.86
DAX 30 0.44 0.75
Eurostoxx 0.43 0.79

Financial crisis

Eigenvalue Pct of explained variance Cumulative pct of explained variance
comp 1 19.06 29.78 29.78
comp 2 7.72 12.06 41.84
comp 3 3.87 6.04 47.88
comp 4 3.29 5.15 53.03
comp 5 2.45 3.83 56.85
comp 6 2.17 3.40 60.25
comp 7 2.02 3.16 63.41
comp 8 1.76 2.75 66.16
comp 9 1.48 2.32 68.47
comp 10 1.25 1.95 70.42
comp 11 1.13 1.76 72.19
comp 12 1.07 1.68 73.86
comp 13 1.01 1.57 75.44
comp 14 0.98 1.53 76.97
comp 15 0.89 1.39 78.36
comp 16 0.85 1.32 79.68
comp 17 0.77 1.20 80.88
comp 18 0.74 1.16 82.04
comp 19 0.70 1.09 83.14
comp 20 0.65 1.02 84.16
comp 21 0.63 0.98 85.14
comp 22 0.60 0.93 86.07
comp 23 0.56 0.87 86.94
comp 24 0.54 0.84 87.78
comp 25 0.50 0.78 88.56
comp 26 0.49 0.76 89.32
comp 27 0.46 0.71 90.04
comp 28 0.44 0.69 90.73
comp 29 0.43 0.68 91.41
comp 30 0.42 0.65 92.06
comp 31 0.40 0.62 92.68
comp 32 0.36 0.57 93.25
comp 33 0.34 0.54 93.79
comp 34 0.32 0.50 94.29
comp 35 0.30 0.47 94.76
comp 36 0.29 0.46 95.22
comp 37 0.28 0.43 95.65
comp 38 0.25 0.40 96.05
comp 39 0.23 0.36 96.41
comp 40 0.22 0.34 96.75
comp 41 0.21 0.32 97.07
comp 42 0.20 0.31 97.38
comp 43 0.18 0.29 97.67
comp 44 0.16 0.26 97.92
comp 45 0.15 0.23 98.16
comp 46 0.13 0.21 98.36
comp 47 0.12 0.19 98.55
comp 48 0.11 0.17 98.72
comp 49 0.11 0.17 98.89
comp 50 0.10 0.16 99.05
comp 51 0.08 0.13 99.18
comp 52 0.07 0.11 99.29
comp 53 0.07 0.11 99.40
comp 54 0.06 0.10 99.50
comp 55 0.06 0.09 99.59
comp 56 0.05 0.08 99.67
comp 57 0.05 0.07 99.74
comp 58 0.04 0.07 99.81
comp 59 0.03 0.05 99.86
comp 60 0.03 0.05 99.91
comp 61 0.02 0.03 99.94
comp 62 0.02 0.02 99.97
comp 63 0.01 0.02 99.98
comp 64 0.01 0.02 100.00
comp 1 comp 2 comp 3 comp 4 comp 5 comp 6 comp 7 comp 8 comp 9 comp 10 comp 11 comp 12 comp 13 comp 14 comp 15 comp 16 comp 17 comp 18 comp 19 comp 20
10yr T-Notes 0.93
5 yr T-Notes US 0.91
Treasury Bonds 0.85
2 yr T-Note US 0.84
Eurodollar 0.78 0.33
Canadian Bond 0.72
Japanese Yen 0.38 0.31 -0.33 -0.50
Euro-Bund 0.37 0.75 -0.37
Euro-Bobl 0.33 0.84
Gilts UK 0.33 0.64 -0.43
Euro-Schatz 0.84
Swiss Franc 0.82
Euroswiss 0.74
Euribor 0.87
Gold 0.36 0.78
Euro 0.90
JGB Japan 0.83
Canadian Dollar -0.50 -0.49
Kerosene 0.35 0.80
Silver 0.41 0.73
NIKKEI 225 0.31 0.70 -0.34
Euroyen 0.89
British Pound 0.63 0.38
Palladium 0.57 0.34
Zinc 0.79
Sugar 0.65
Cotton 0.38 0.50
Natural Gas 0.89
Coffee 0.31 0.70
Cocoa 0.35 0.44 0.34
Hang Seng 0.76
Singapore Dollar 0.72
Corn 0.72
Aluminium 0.70
Orange Juice 0.96
Gas Oil 0.49 0.57
Soybean Meal 0.88
Lean Hoggs 0.92
Brent Crude 0.86
Platinum 0.84
New Zealand Dollar 0.63 0.35
Soybeans 0.88
Canola 0.79
Copper LDN 0.77
Soybean Oil 0.72 0.36
Heating Oil 0.84
Gasoline 0.84
Wheat 0.60
Copper NY 0.72
Norwegian Krone 0.78
Australian Dollar 0.54 0.32 0.34
Nickel 0.71
Lumber 0.91
DAX 30 0.35 0.79
Eurostoxx 0.82
FTSE 100 UK 0.78
OMX 30 Stockholm 0.31 0.76
CAC 40 France 0.80
Crude Oil 0.82
TSE Toronto 0.70
Dow Jones 0.91
Russel 2000 E-Mini 0.90
SP500 E-Mini 0.90
Nasdaq 100 Mini 0.89

Answer 5:

There are some differences between bullish and bearish years. For example, in bearish years importance of agriculture commodities increased (from 7 to 3). On top of that, importance of Euro decreased.

Assets in bull years

1 [1] “5 yr T-Notes US, 10yr T-Notes, 2 yr T-Note US, Treasury Bonds, Eurodollar, Canadian Bond”

2 [1] “Swiss Franc, Euro, British Pound, Norwegian Krone, Japanese Yen, Australian Dollar, New Zealand Dollar, Singapore Dollar”

3 [1] “Euro-Bund, Euro-Bobl, Euro-Schatz, Gilts UK, Euribor, Euroswiss”

4 [1] “Copper LDN, Nickel, Copper NY, Aluminium, Zinc”

5 [1] “Heating Oil, Natural Gas, Brent Crude, Crude Oil, Gas Oil”

6 [1] “TSE Toronto, SP500 E-Mini, Dow Jones, Nasdaq 100 Mini”

7 [1] “Corn, Soybean Meal, Soybeans, Soybean Oil, Canola”

8 [1] “FTSE 100 UK, CAC 40 France, DAX 30, Eurostoxx”

9 [1] “Gold, Silver, Platinum, Palladium”

10 [1] “Hang Seng, NIKKEI 225”

Assets in bear years

1 [1] “10yr T-Notes, 5 yr T-Notes US, Treasury Bonds, 2 yr T-Note US, Eurodollar, Canadian Bond”

2 [1] “Swiss Franc, Euro, British Pound, Singapore Dollar, New Zealand Dollar, Norwegian Krone, Australian Dollar”

3 [1] “Corn, Soybean Meal, Soybeans, Canola, Soybean Oil, Wheat”

4 [1] “TSE Toronto, Dow Jones, Russel 2000 E-Mini, SP500 E-Mini, Nasdaq 100 Mini”

5 [1] “Euro-Bund, Euro-Bobl, Gilts UK, Euro-Schatz, Euroswiss, Euribor”

6 [1] “DAX 30, Eurostoxx, FTSE 100 UK, OMX 30 Stockholm, CAC 40 France”

7 [1] “Brent Crude, Heating Oil, Gasoline, Crude Oil”

8 [1] “Zinc, Aluminium, Copper LDN, Copper NY, Nickel”

9 [1] “NIKKEI 225, Hang Seng”

10 [1] “Gold, Silver, Palladium”

A Simple Futures Trend Following Strategy

We can now develop a simple futures trend following trading strategy, as outlined in the papers in the Exercise Introduction above. There are about $300 billion invested in such strategies! Of course we cannot develop here a sophisticated product, but with some more work…

We will do the following:

  1. Calculate a number of moving averages of different “window lengths” for each of the 64 futures - there are many so called technical indicators one can use. We will use the “moving average” function ma for this (try for example to see what this returns ma(1:10,2) ).
  2. Add the signs (can also use the actual moving average values of course - try it!) of these moving averages (as if they “vote”), and then scale this sum across all futures so that the sum of their (of the sum across all futures!) absolute value across all futures is 1 (hence we invest $1 every day - you see why?).
  3. Then invest every day in each of the 64 an amount that is defined by the weights calculated in step 2, using however the weights calculated using data until 2 days ago (why 2 days and not 1 day?) - see the use of the helper function shift for this.
  4. Finally see the performance of this strategy.

Here is the code:

signal_used = 0 * futures_data  # just initialize the trading signal to be 0

# Take many moving Average (MA) Signals and let them 'vote' with their sign
# (+-1, e.g. long or short vote, for each signal)
MAfreq <- seq(10, 250, by = 20)

for (iter in 1:length(MAfreq)) {
    d = apply(futures_data, 2, function(r) {
        ma(r, MAfreq[iter])
    })
    signal_used = signal_used + sign(d)
}

# Now make sure we invest $1 every day (so the sum of the absolute values of
# the weights is 1 every day)
signal_used = t(apply(signal_used, 1, function(r) {
    res = r
    if (sum(abs(r)) != 0) 
        res = r/sum(abs(r))
    res
}))
colnames(signal_used) <- colnames(futures_data)

# Now create the returns of the strategy for each futures time series
s <- shift(signal_used, 2)
strategy_by_future <- scrub(s * futures_data)  # signal 2 days ago

# finally, this is our futures trend following strategy
trading_strategy = apply(strategy_by_future, 1, sum)

names(trading_strategy) <- rownames(futures_data)

Reporting the performance results

Let’s see how this strategy does:

Here is how this strategy has performed during this period:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year
2001 0.61 1.55 1.81 -2.00 0.54 0.69 0.75 1.35 4.30 0.33 -2.26 -2.45 5.13
2002 0.20 -0.44 -2.61 1.01 0.39 1.72 2.06 1.65 3.38 -2.50 -1.27 3.07 6.64
2003 2.39 3.37 -2.85 -0.92 1.25 -1.25 0.73 -0.13 -0.33 4.23 0.10 3.10 9.86
2004 1.22 3.16 0.06 -1.66 -0.13 -1.40 3.00 -2.75 4.36 -0.77 0.98 -0.07 5.91
2005 -0.55 1.03 0.27 -2.03 -0.27 0.84 0.42 1.51 0.25 -1.05 2.17 0.30 2.86
2006 2.00 -0.87 2.05 3.85 -0.30 -1.63 -0.76 0.00 0.60 2.23 0.50 1.17 9.05
2007 0.13 -0.52 -0.96 1.69 0.01 0.77 -0.90 -1.28 3.15 1.81 -0.05 1.98 5.88
2008 2.52 5.71 -3.06 0.36 2.38 4.06 -4.41 -1.66 5.35 14.30 3.88 1.61 34.20
2009 1.23 2.07 -5.43 -2.20 -0.82 -0.93 1.92 3.00 0.12 0.39 2.02 0.91 2.01
2010 -3.39 0.19 3.88 1.10 -5.04 -2.45 -1.27 0.01 2.31 3.59 -1.06 6.41 3.75
2011 1.27 2.48 -1.58 2.63 -4.07 -2.15 0.58 -0.77 1.23 -4.67 0.63 -0.38 -5.01
2012 -0.94 0.20 0.34 -0.12 1.57 -1.80 1.35 -0.33 -0.74 -0.92 -0.36 0.13 -1.65
2013 1.29 -0.58 1.07 0.15 1.29 0.52 0.51 -0.72 0.14 0.42 1.29 0.44 5.96
2014 -1.12 0.80 -0.11 0.54 -0.41 -0.16 0.69 0.96 0.89 0.52 2.53 2.64 7.98
2015 1.77 -0.73 1.63 -2.32 0.39 -0.43 1.50 -1.70 1.17 1.18

How does this compare with existing CTA products such as this one from Societe Generale? (Note: one can easily achieve a correlation of more than 0.8 with this specific product - as well as with many other ones)

Compare our strategy with this product

Compare our strategy with this product

Questions

  1. Can you describe in more detail what the code above does?
  2. What happens if you use different moving average technical indicators in the code above? Please explore and report below the returns of a trading strategy you build. (Hint: check that the command line MAfreq<-seq(10,250,by=20) above does for example - but not only of course, the possibilities are endless)

Answers

  1. The above code calculates effectiveness of used trend following approach. It starts off with creation of array that has the same size as future_data. Then it calculates moving averages of returns in different periods (from 10 to 250 days). Based on that it determines signals of trend. Positive number means that price of given futures rise (negative that it declines). Then it distributes $1 over each futures so that total is $1. It means that futures with negative signal (short signal) are being sold and the ones with positive signal (long signal) are being bought. After that, we summarize the data (w/ 2 days shift) and add results up. Then data is plotted.

  2. Current returns: 91.4%
    Returns after modifcations (MAfreq<-seq(10,250,by=10)): 92.09%

A class competition

Now you have seen how to develop some trading strategies that hedge funds have been using for centuries. Clearly this is only the very first step - as many of the online resources on technical indicators also suggest. Can you now explore more such strategies? How good a futures trend following hedge fund strategy can you develop? Let’s call this…. a class competition! Explore as much as you can and report your best strategy as we move along the course…

Here is for example something that can be achieved relatively easily…

Here is how this strategy has performed during this period:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year
2001 0.00 0.00 0.68 -1.00 0.02 -0.05 0.60 0.95 2.41 1.25 -2.21 -0.98 1.59
2002 -0.56 -0.18 -0.81 0.21 1.09 1.92 1.85 1.25 1.75 -0.93 -0.68 2.76 7.85
2003 1.33 1.53 -0.83 0.12 1.86 -0.90 -0.31 -0.20 -0.03 1.98 0.09 1.82 6.58
2004 0.76 1.90 -0.07 -1.83 -0.19 -0.32 0.33 -1.02 1.32 0.19 1.33 0.26 2.62
2005 -0.36 0.37 0.02 -0.70 0.51 0.93 0.13 0.17 0.69 -0.04 1.55 0.41 3.72
2006 1.21 -0.04 2.10 2.03 -0.42 -0.17 -0.89 -0.54 -0.15 0.95 0.71 0.73 5.61
2007 0.39 -0.98 -0.08 1.70 1.18 1.33 -1.27 -2.41 2.01 1.11 0.29 0.67 3.92
2008 2.60 2.96 -0.98 -0.37 0.69 1.68 -1.97 -0.14 1.78 4.35 1.62 0.73 13.57
2009 0.05 0.72 -1.36 -1.15 0.41 -0.73 0.88 0.83 0.71 -0.14 1.64 -0.63 1.19
2010 -1.26 0.47 1.34 0.77 -1.30 -0.49 -0.45 1.10 1.04 1.67 -0.89 2.38 4.38
2011 0.58 1.16 -0.69 1.74 -1.71 -1.50 0.98 0.64 0.81 -1.86 0.46 0.39 0.93
2012 -0.29 -0.15 -0.05 -0.10 1.27 -1.08 0.66 -0.25 -0.22 -0.77 -0.18 -0.13 -1.31
2013 1.09 -0.98 0.82 -0.03 0.72 0.85 0.20 -0.26 0.12 0.23 0.90 1.01 4.73
2014 -1.33 0.46 -0.12 0.06 0.32 0.42 0.01 1.15 1.85 0.68 2.07 1.49 7.24
2015 2.17 -0.30 1.10 -1.49 0.27 0.04 0.40 -0.77 0.73 2.11

As always, have fun